Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | ExternalDepositoryDocument(LE_HST_EXTDST) |
TenderRepositoryID (FK)(PK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | ExternalDepositoryDocument(LE_HST_EXTDST) |
TenderTypeCode (FK)(PK) | A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. Sample Values: CASH - currency CREDIT - credit card DEBIT - debit card CUST_ACCT - customer credit account with retailer EBT - electronic benefits transfer CHEQUE - personal or business cheque STORED_VALUE - gift cert. or gift card COUPON - mfg coupon VOUCHER - retailer issued debit (e.g. coinstar voucher) SEND_CHECK - paid out/refund via acct pay. TRADEIN - trade in kind/trade in debit OTHER - other debit offset tender type | TY_TND | Code | varchar(20) | Tender(AS_TND) |
OpenBalanceAmount | The opening tender balance in the EXTERNAL TENDER DEPOSITORY for an external depositoryl settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. | MO_OPN_BLNC_AMT | Money | decimal(16,5) | |
OpenMediaUnitQuantity | The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. | QU_OPN_MD_UN | QuantityInteger | integer | |
CloseBalanceAmount | The closing tender balance in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. The closing balance represents the system's total. | MO_CL_BLNC_AMT | Money | decimal(16,5) | |
CloseMediaUnitQuantity | The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. | QU_CL_MD_UN | QuantityInteger | integer | |
CountedBalanceAmount | The counted tender balance in the EXTERNAL TENDER DEPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of an external depository settlement period. | MO_CNT_BLNC_AMT | Money | decimal(16,5) | |
CountedMediaUnitQuantity | The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the EXTERNAL TENDER REPOSITORY for an external depository settlement period which is the time period bounded by two ExternalDepositorySettlementTransactions. | QU_CNT_MD_UN | QuantityInteger | integer | |
OverUnderBalanceAmount | The variance between closing balance amount and counted balance amount at the end of an external depository settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) | MO_OVR_UND_BLNC_AMT | Money | decimal(16,5) | |
OverUnderMediaUnitQuantity | The variance between closing media unit quantity and counted media unit quantity at the end of an external depository settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) | QU_OVR_UND_MD_UN | QuantityInteger | integer | |
DepositFromSafeAmount | The sum of deposits made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period. This is money moving from the store safe into the bank. | MO_DS_FRM_SF_AMT | Money | decimal(16,5) | |
DepositFromSafeMediaUnitQuantity | The sum of tender media unit quantities made from store SAFES into this TENDER DEPOSITORY for the tender depository settlement period. This is money moving from the store safe into the bank. | QU_DS_FRM_SF_MD_UN | QuantityInteger | integer | |
ReceiptToSafeAmount | The sum of tender withdrawn from this external depository (bank) and received into store safes for an external depository settlement period. This represents tender pulled out from a bank and received into a safe for use in making change. | MO_RCPT_TO_SF_AMT | Money | decimal(16,5) | |
ReceiptToSafeMediaUnitQuantity | The sum of tender media unit quantities withdrawn from this external depository (bank) and received into store safes for an external depository settlement period. This represents tender pulled out from a bank and received into a safe for use in making change. | QU_RCPT_TO_SF_MD_UN | QuantityInteger | integer | |